Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 756 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 108.7 KiB |
| Average record size in memory | 147.2 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 10 |
date has a high cardinality: 756 distinct values | High cardinality |
oil_brent is highly overall correlated with oil_dubai and 7 other fields | High correlation |
oil_dubai is highly overall correlated with oil_brent and 7 other fields | High correlation |
coffee_arabica is highly overall correlated with oil_brent and 7 other fields | High correlation |
coffee_robustas is highly overall correlated with coffee_arabica and 2 other fields | High correlation |
tea_columbo is highly overall correlated with oil_brent and 6 other fields | High correlation |
tea_kolkata is highly overall correlated with oil_brent and 7 other fields | High correlation |
tea_mombasa is highly overall correlated with oil_brent and 7 other fields | High correlation |
sugar_eu is highly overall correlated with oil_brent and 1 other fields | High correlation |
sugar_us is highly overall correlated with oil_brent and 6 other fields | High correlation |
sugar_world is highly overall correlated with oil_brent and 6 other fields | High correlation |
date is uniformly distributed | Uniform |
date has unique values | Unique |
Reproduction
| Analysis started | 2023-11-15 21:49:56.111161 |
|---|---|
| Analysis finished | 2023-11-15 21:50:26.651759 |
| Duration | 30.54 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
date
Categorical
HIGH CARDINALITY UNIFORM UNIQUE
| Distinct | 756 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 49.6 KiB |
| 1960-01-01 | 1 |
|---|---|
| 2002-05-01 | 1 |
| 2001-08-01 | 1 |
| 2001-09-01 | 1 |
| 2001-10-01 | 1 |
| Other values (751) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 7560 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 756 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 1960-01-01 |
|---|---|
| 2nd row | 1960-02-01 |
| 3rd row | 1960-03-01 |
| 4th row | 1960-04-01 |
| 5th row | 1960-05-01 |
Common Values
| Value | Count | Frequency (%) |
| 1960-01-01 | 1 | 0.1% |
| 2002-05-01 | 1 | 0.1% |
| 2001-08-01 | 1 | 0.1% |
| 2001-09-01 | 1 | 0.1% |
| 2001-10-01 | 1 | 0.1% |
| 2001-11-01 | 1 | 0.1% |
| 2001-12-01 | 1 | 0.1% |
| 2002-01-01 | 1 | 0.1% |
| 2002-02-01 | 1 | 0.1% |
| 2002-03-01 | 1 | 0.1% |
| Other values (746) | 746 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1960-01-01 | 1 | 0.1% |
| 1960-11-01 | 1 | 0.1% |
| 1961-10-01 | 1 | 0.1% |
| 1960-03-01 | 1 | 0.1% |
| 1960-04-01 | 1 | 0.1% |
| 1960-05-01 | 1 | 0.1% |
| 1960-06-01 | 1 | 0.1% |
| 1960-07-01 | 1 | 0.1% |
| 1960-08-01 | 1 | 0.1% |
| 1960-09-01 | 1 | 0.1% |
| Other values (746) | 746 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1866 | |
| 1 | 1755 | |
| - | 1512 | |
| 9 | 735 | 9.7% |
| 2 | 522 | 6.9% |
| 6 | 255 | 3.4% |
| 8 | 255 | 3.4% |
| 7 | 255 | 3.4% |
| 5 | 135 | 1.8% |
| 3 | 135 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6048 | |
| Dash Punctuation | 1512 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1866 | |
| 1 | 1755 | |
| 9 | 735 | 12.2% |
| 2 | 522 | 8.6% |
| 6 | 255 | 4.2% |
| 8 | 255 | 4.2% |
| 7 | 255 | 4.2% |
| 5 | 135 | 2.2% |
| 3 | 135 | 2.2% |
| 4 | 135 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7560 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1866 | |
| 1 | 1755 | |
| - | 1512 | |
| 9 | 735 | 9.7% |
| 2 | 522 | 6.9% |
| 6 | 255 | 3.4% |
| 8 | 255 | 3.4% |
| 7 | 255 | 3.4% |
| 5 | 135 | 1.8% |
| 3 | 135 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7560 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1866 | |
| 1 | 1755 | |
| - | 1512 | |
| 9 | 735 | 9.7% |
| 2 | 522 | 6.9% |
| 6 | 255 | 3.4% |
| 8 | 255 | 3.4% |
| 7 | 255 | 3.4% |
| 5 | 135 | 1.8% |
| 3 | 135 | 1.8% |
oil_brent
Real number (ℝ)
| Distinct | 528 |
|---|---|
| Distinct (%) | 69.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.724944 |
| Minimum | 1.21 |
|---|---|
| Maximum | 133.87304 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 1.21 |
|---|---|
| 5-th percentile | 1.33 |
| Q1 | 10.564999 |
| median | 20.48913 |
| Q3 | 47.1575 |
| 95-th percentile | 108.25964 |
| Maximum | 133.87304 |
| Range | 132.66304 |
| Interquartile range (IQR) | 36.592501 |
Descriptive statistics
| Standard deviation | 31.885368 |
|---|---|
| Coefficient of variation (CV) | 0.97434447 |
| Kurtosis | 0.59426373 |
| Mean | 32.724944 |
| Median Absolute Deviation (MAD) | 18.40913 |
| Skewness | 1.203709 |
| Sum | 24740.058 |
| Variance | 1016.6767 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.630000114 | 12 | 1.6% |
| 1.36 | 12 | 1.6% |
| 1.57 | 12 | 1.6% |
| 1.21 | 12 | 1.6% |
| 1.32 | 12 | 1.6% |
| 1.33 | 12 | 1.6% |
| 1.27 | 12 | 1.6% |
| 1.42 | 12 | 1.6% |
| 1.45 | 12 | 1.6% |
| 1.5 | 12 | 1.6% |
| Other values (518) | 636 |
| Value | Count | Frequency (%) |
| 1.21 | 12 | |
| 1.27 | 12 | |
| 1.32 | 12 | |
| 1.33 | 12 | |
| 1.36 | 12 | |
| 1.42 | 12 | |
| 1.45 | 12 | |
| 1.5 | 12 | |
| 1.52 | 12 | |
| 1.57 | 12 |
| Value | Count | Frequency (%) |
| 133.8730435 | 1 | |
| 133.0485714 | 1 | |
| 124.9286364 | 1 | |
| 123.9361905 | 1 | |
| 123.07 | 1 | |
| 120.4635 | 1 | |
| 120.08 | 1 | |
| 119.702381 | 1 | |
| 116.5195 | 1 | |
| 116.46 | 1 |
oil_dubai
Real number (ℝ)
| Distinct | 524 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.23813 |
| Minimum | 1.21 |
|---|---|
| Maximum | 131.22478 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 1.21 |
|---|---|
| 5-th percentile | 1.33 |
| Q1 | 10.4525 |
| median | 18.55 |
| Q3 | 45.576023 |
| 95-th percentile | 104.96917 |
| Maximum | 131.22478 |
| Range | 130.01478 |
| Interquartile range (IQR) | 35.123523 |
Descriptive statistics
| Standard deviation | 30.936611 |
|---|---|
| Coefficient of variation (CV) | 0.99034774 |
| Kurtosis | 0.62002136 |
| Mean | 31.23813 |
| Median Absolute Deviation (MAD) | 16.68 |
| Skewness | 1.2311269 |
| Sum | 23616.026 |
| Variance | 957.07392 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.630000114 | 12 | 1.6% |
| 1.57 | 12 | 1.6% |
| 1.52 | 12 | 1.6% |
| 1.5 | 12 | 1.6% |
| 1.45 | 12 | 1.6% |
| 1.42 | 12 | 1.6% |
| 1.36 | 12 | 1.6% |
| 1.33 | 12 | 1.6% |
| 1.32 | 12 | 1.6% |
| 1.27 | 12 | 1.6% |
| Other values (514) | 636 |
| Value | Count | Frequency (%) |
| 1.21 | 12 | |
| 1.27 | 12 | |
| 1.32 | 12 | |
| 1.33 | 12 | |
| 1.36 | 12 | |
| 1.42 | 12 | |
| 1.45 | 12 | |
| 1.5 | 12 | |
| 1.52 | 12 | |
| 1.57 | 12 |
| Value | Count | Frequency (%) |
| 131.2247826 | 1 | |
| 127.587619 | 1 | |
| 122.2759091 | 1 | |
| 118.9486364 | 1 | |
| 117.25 | 1 | |
| 116.1461905 | 1 | |
| 115.73 | 1 | |
| 115.7 | 1 | |
| 113.2109524 | 1 | |
| 113.11 | 1 |
coffee_arabica
Real number (ℝ)
| Distinct | 733 |
|---|---|
| Distinct (%) | 97.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5765548 |
| Minimum | 0.7776 |
|---|---|
| Maximum | 7.0036 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.7776 |
|---|---|
| 5-th percentile | 0.854325 |
| Q1 | 1.351625 |
| median | 2.6977944 |
| Q3 | 3.31295 |
| 95-th percentile | 4.97505 |
| Maximum | 7.0036 |
| Range | 6.226 |
| Interquartile range (IQR) | 1.961325 |
Descriptive statistics
| Standard deviation | 1.3424536 |
|---|---|
| Coefficient of variation (CV) | 0.52102659 |
| Kurtosis | -0.10152662 |
| Mean | 2.5765548 |
| Median Absolute Deviation (MAD) | 1.03925 |
| Skewness | 0.59039769 |
| Sum | 1947.8754 |
| Variance | 1.8021816 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.8891 | 3 | 0.4% |
| 2.9427 | 2 | 0.3% |
| 0.8929 | 2 | 0.3% |
| 2.976898386 | 2 | 0.3% |
| 0.8267 | 2 | 0.3% |
| 3.10630958 | 2 | 0.3% |
| 0.9026 | 2 | 0.3% |
| 0.8109 | 2 | 0.3% |
| 0.8047 | 2 | 0.3% |
| 0.8256 | 2 | 0.3% |
| Other values (723) | 735 |
| Value | Count | Frequency (%) |
| 0.7776 | 1 | |
| 0.795 | 1 | |
| 0.797 | 1 | |
| 0.7992 | 1 | |
| 0.7998 | 1 | |
| 0.802 | 1 | |
| 0.8031 | 1 | |
| 0.8042 | 1 | |
| 0.8047 | 2 | |
| 0.8064 | 1 |
| Value | Count | Frequency (%) |
| 7.0036 | 1 | |
| 6.7058 | 1 | |
| 6.616505544 | 1 | |
| 6.439033634 | 1 | |
| 6.417428358 | 1 | |
| 6.346880518 | 1 | |
| 6.2889 | 1 | |
| 6.169188146 | 1 | |
| 6.062264076 | 1 | |
| 6.060059456 | 1 |
coffee_robustas
Real number (ℝ)
| Distinct | 715 |
|---|---|
| Distinct (%) | 94.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7274784 |
| Minimum | 0.4872098 |
|---|---|
| Maximum | 6.883547 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.4872098 |
|---|---|
| 5-th percentile | 0.66390605 |
| Q1 | 0.92305308 |
| median | 1.6321718 |
| Q3 | 2.2822 |
| 95-th percentile | 3.4715457 |
| Maximum | 6.883547 |
| Range | 6.3963372 |
| Interquartile range (IQR) | 1.3591469 |
Descriptive statistics
| Standard deviation | 0.94074785 |
|---|---|
| Coefficient of variation (CV) | 0.54457866 |
| Kurtosis | 2.5466008 |
| Mean | 1.7274784 |
| Median Absolute Deviation (MAD) | 0.69015937 |
| Skewness | 1.1896824 |
| Sum | 1305.9736 |
| Variance | 0.88500652 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.6684254 | 5 | 0.7% |
| 0.6723936 | 4 | 0.5% |
| 0.6968643 | 3 | 0.4% |
| 0.6765823 | 3 | 0.4% |
| 0.9298873 | 3 | 0.4% |
| 0.6117679 | 3 | 0.4% |
| 0.6157362 | 3 | 0.4% |
| 0.9400282 | 3 | 0.4% |
| 2.041257658 | 2 | 0.3% |
| 0.6887074 | 2 | 0.3% |
| Other values (705) | 725 |
| Value | Count | Frequency (%) |
| 0.4872098 | 1 | |
| 0.5029 | 1 | |
| 0.5124 | 1 | |
| 0.5221 | 1 | |
| 0.5351 | 1 | |
| 0.5368 | 1 | |
| 0.5373 | 1 | |
| 0.5469536 | 1 | |
| 0.5692 | 1 | |
| 0.5798017 | 1 |
| Value | Count | Frequency (%) |
| 6.883547 | 1 | |
| 6.747966 | 1 | |
| 5.942636 | 1 | |
| 5.431397 | 1 | |
| 4.938676 | 1 | |
| 4.767601 | 1 | |
| 4.496439 | 1 | |
| 4.482551 | 1 | |
| 4.442207 | 1 | |
| 4.331758 | 1 |
tea_columbo
Real number (ℝ)
| Distinct | 608 |
|---|---|
| Distinct (%) | 80.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7779616 |
| Minimum | 0.4341979 |
|---|---|
| Maximum | 4.49 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.4341979 |
|---|---|
| 5-th percentile | 0.635353 |
| Q1 | 0.8925009 |
| median | 1.5040005 |
| Q3 | 2.5152043 |
| 95-th percentile | 3.6025 |
| Maximum | 4.49 |
| Range | 4.0558021 |
| Interquartile range (IQR) | 1.6227034 |
Descriptive statistics
| Standard deviation | 1.0086791 |
|---|---|
| Coefficient of variation (CV) | 0.56732334 |
| Kurtosis | -0.66875673 |
| Mean | 1.7779616 |
| Median Absolute Deviation (MAD) | 0.6576996 |
| Skewness | 0.74423496 |
| Sum | 1344.139 |
| Variance | 1.0174335 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.9303009 | 12 | 1.6% |
| 0.8610009 | 12 | 1.6% |
| 0.8148008 | 12 | 1.6% |
| 0.8190008 | 12 | 1.6% |
| 0.8463009 | 12 | 1.6% |
| 0.7602008 | 12 | 1.6% |
| 0.6770413 | 12 | 1.6% |
| 0.5964011 | 12 | 1.6% |
| 0.6266412 | 12 | 1.6% |
| 0.8925009 | 12 | 1.6% |
| Other values (598) | 636 |
| Value | Count | Frequency (%) |
| 0.4341979 | 1 | 0.1% |
| 0.5221966 | 1 | 0.1% |
| 0.5455723 | 1 | 0.1% |
| 0.5837871 | 1 | 0.1% |
| 0.5846411 | 1 | 0.1% |
| 0.5964011 | 12 | |
| 0.6023916 | 1 | 0.1% |
| 0.6031651 | 1 | 0.1% |
| 0.6047198 | 1 | 0.1% |
| 0.617284 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 4.49 | 1 | |
| 4.27 | 1 | |
| 4.21 | 1 | |
| 4.19 | 1 | |
| 4.16 | 1 | |
| 4.135620511 | 1 | |
| 4.13 | 1 | |
| 4.11 | 2 | |
| 4.1 | 1 | |
| 4.09 | 1 |
tea_kolkata
Real number (ℝ)
| Distinct | 634 |
|---|---|
| Distinct (%) | 83.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8703082 |
| Minimum | 0.6647995 |
|---|---|
| Maximum | 4.0730112 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.6647995 |
|---|---|
| 5-th percentile | 0.7986667 |
| Q1 | 1.2973687 |
| median | 1.8506122 |
| Q3 | 2.3768987 |
| 95-th percentile | 3.0886475 |
| Maximum | 4.0730112 |
| Range | 3.4082117 |
| Interquartile range (IQR) | 1.07953 |
Descriptive statistics
| Standard deviation | 0.69786695 |
|---|---|
| Coefficient of variation (CV) | 0.3731294 |
| Kurtosis | -0.55790982 |
| Mean | 1.8703082 |
| Median Absolute Deviation (MAD) | 0.53728308 |
| Skewness | 0.26941242 |
| Sum | 1413.953 |
| Variance | 0.48701829 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.121401 | 12 | 1.6% |
| 0.7986667 | 12 | 1.6% |
| 0.978601 | 12 | 1.6% |
| 0.9906667 | 12 | 1.6% |
| 0.7333334 | 12 | 1.6% |
| 0.8626667 | 12 | 1.6% |
| 1.142401 | 12 | 1.6% |
| 1.039501 | 12 | 1.6% |
| 1.083601 | 12 | 1.6% |
| 1.104601 | 12 | 1.6% |
| Other values (624) | 636 |
| Value | Count | Frequency (%) |
| 0.6647995 | 1 | 0.1% |
| 0.6855978 | 1 | 0.1% |
| 0.7084 | 1 | 0.1% |
| 0.7098448 | 1 | 0.1% |
| 0.7105354 | 1 | 0.1% |
| 0.7253865 | 1 | 0.1% |
| 0.7323374 | 1 | 0.1% |
| 0.7333334 | 12 | |
| 0.7353197 | 1 | 0.1% |
| 0.7530807 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 4.073011154 | 1 | |
| 3.990422346 | 1 | |
| 3.957038 | 1 | |
| 3.856839612 | 1 | |
| 3.550720905 | 1 | |
| 3.538153514 | 1 | |
| 3.504758045 | 1 | |
| 3.469254 | 1 | |
| 3.412294528 | 1 | |
| 3.351542111 | 1 |
tea_mombasa
Real number (ℝ)
| Distinct | 531 |
|---|---|
| Distinct (%) | 70.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6712216 |
| Minimum | 0.7195997 |
|---|---|
| Maximum | 3.3925 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.7195997 |
|---|---|
| 5-th percentile | 0.8357997 |
| Q1 | 1.1368 |
| median | 1.5982575 |
| Q3 | 2.0838297 |
| 95-th percentile | 2.874375 |
| Maximum | 3.3925 |
| Range | 2.6729003 |
| Interquartile range (IQR) | 0.94702967 |
Descriptive statistics
| Standard deviation | 0.61535745 |
|---|---|
| Coefficient of variation (CV) | 0.36820818 |
| Kurtosis | -0.47147177 |
| Mean | 1.6712216 |
| Median Absolute Deviation (MAD) | 0.4614575 |
| Skewness | 0.53555512 |
| Sum | 1263.4435 |
| Variance | 0.37866479 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.0374 | 12 | 1.6% |
| 0.8357997 | 12 | 1.6% |
| 0.9841996 | 12 | 1.6% |
| 1.1368 | 12 | 1.6% |
| 0.8105997 | 12 | 1.6% |
| 0.8875996 | 12 | 1.6% |
| 0.7195997 | 12 | 1.6% |
| 0.9015996 | 12 | 1.6% |
| 0.9911996 | 12 | 1.6% |
| 0.9141996 | 12 | 1.6% |
| Other values (521) | 636 |
| Value | Count | Frequency (%) |
| 0.7195997 | 12 | |
| 0.8105997 | 12 | |
| 0.8203997 | 5 | |
| 0.8357997 | 12 | |
| 0.8492754 | 7 | |
| 0.8875996 | 12 | |
| 0.9015996 | 12 | |
| 0.9141996 | 12 | |
| 0.9225996 | 12 | |
| 0.9533996 | 12 |
| Value | Count | Frequency (%) |
| 3.3925 | 1 | |
| 3.268 | 1 | |
| 3.24 | 1 | |
| 3.17 | 1 | |
| 3.1375 | 1 | |
| 3.1025 | 1 | |
| 3.0925 | 1 | |
| 3.0825 | 1 | |
| 3.077708 | 1 | |
| 3.076666667 | 1 |
sugar_eu
Real number (ℝ)
| Distinct | 592 |
|---|---|
| Distinct (%) | 78.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4051577 |
| Minimum | 0.11221516 |
|---|---|
| Maximum | 0.78317064 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.11221516 |
|---|---|
| 5-th percentile | 0.11221516 |
| Q1 | 0.29811974 |
| median | 0.40234315 |
| Q3 | 0.56951938 |
| 95-th percentile | 0.6808 |
| Maximum | 0.78317064 |
| Range | 0.67095548 |
| Interquartile range (IQR) | 0.27139964 |
Descriptive statistics
| Standard deviation | 0.18774134 |
|---|---|
| Coefficient of variation (CV) | 0.46337844 |
| Kurtosis | -1.0493253 |
| Mean | 0.4051577 |
| Median Absolute Deviation (MAD) | 0.14906998 |
| Skewness | -0.16765975 |
| Sum | 306.29922 |
| Variance | 0.035246812 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.112215158 | 43 | 5.7% |
| 0.12676565 | 23 | 3.0% |
| 0.12456103 | 13 | 1.7% |
| 0.12235641 | 12 | 1.6% |
| 0.129411194 | 12 | 1.6% |
| 0.124340568 | 12 | 1.6% |
| 0.130954428 | 12 | 1.6% |
| 0.126324726 | 12 | 1.6% |
| 0.295639542 | 4 | 0.5% |
| 0.40234315 | 3 | 0.4% |
| Other values (582) | 610 |
| Value | Count | Frequency (%) |
| 0.112215158 | 43 | |
| 0.113758392 | 1 | 0.1% |
| 0.115522088 | 1 | 0.1% |
| 0.116403936 | 1 | 0.1% |
| 0.116624398 | 1 | 0.1% |
| 0.118167632 | 1 | 0.1% |
| 0.12235641 | 12 | 1.6% |
| 0.124340568 | 12 | 1.6% |
| 0.12456103 | 13 | 1.7% |
| 0.126324726 | 12 | 1.6% |
| Value | Count | Frequency (%) |
| 0.78317064 | 1 | |
| 0.7822045029 | 1 | |
| 0.77287176 | 1 | |
| 0.7726612114 | 1 | |
| 0.7714 | 1 | |
| 0.7439769257 | 1 | |
| 0.7326995657 | 1 | |
| 0.7311857236 | 1 | |
| 0.7293000343 | 1 | |
| 0.7239194259 | 1 |
sugar_us
Real number (ℝ)
| Distinct | 595 |
|---|---|
| Distinct (%) | 78.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.43246218 |
| Minimum | 0.11684486 |
|---|---|
| Maximum | 1.2632473 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.11684486 |
|---|---|
| 5-th percentile | 0.13007258 |
| Q1 | 0.2976237 |
| median | 0.4711192 |
| Q3 | 0.51218834 |
| 95-th percentile | 0.78043548 |
| Maximum | 1.2632473 |
| Range | 1.1464024 |
| Interquartile range (IQR) | 0.21456464 |
Descriptive statistics
| Standard deviation | 0.18858876 |
|---|---|
| Coefficient of variation (CV) | 0.43608151 |
| Kurtosis | 0.11824936 |
| Mean | 0.43246218 |
| Median Absolute Deviation (MAD) | 0.081319197 |
| Skewness | 0.10340297 |
| Sum | 326.94141 |
| Variance | 0.035565721 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.12786796 | 14 | 1.9% |
| 0.14991416 | 9 | 1.2% |
| 0.12345872 | 8 | 1.1% |
| 0.13007258 | 8 | 1.1% |
| 0.13889106 | 8 | 1.1% |
| 0.1543234 | 7 | 0.9% |
| 0.15873264 | 7 | 0.9% |
| 0.1322772 | 7 | 0.9% |
| 0.13668644 | 7 | 0.9% |
| 0.14770954 | 7 | 0.9% |
| Other values (585) | 674 |
| Value | Count | Frequency (%) |
| 0.11684486 | 1 | 0.1% |
| 0.11904948 | 1 | 0.1% |
| 0.1212541 | 4 | 0.5% |
| 0.12345872 | 8 | |
| 0.12566334 | 4 | 0.5% |
| 0.12786796 | 14 | |
| 0.13007258 | 8 | |
| 0.1322772 | 7 | |
| 0.13448182 | 3 | 0.4% |
| 0.13668644 | 7 |
| Value | Count | Frequency (%) |
| 1.26324726 | 1 | |
| 1.028234768 | 1 | |
| 0.91932654 | 1 | |
| 0.887405963 | 1 | |
| 0.8852599119 | 1 | |
| 0.88515493 | 1 | |
| 0.8802568395 | 1 | |
| 0.8750903604 | 1 | |
| 0.873911368 | 1 | |
| 0.867692019 | 1 |
sugar_world
Real number (ℝ)
| Distinct | 694 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.24026341 |
| Minimum | 0.0287 |
|---|---|
| Maximum | 1.2377 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0.0287 |
|---|---|
| 5-th percentile | 0.048275 |
| Q1 | 0.13970468 |
| median | 0.21528546 |
| Q3 | 0.309325 |
| 95-th percentile | 0.51980635 |
| Maximum | 1.2377 |
| Range | 1.209 |
| Interquartile range (IQR) | 0.16962032 |
Descriptive statistics
| Standard deviation | 0.15194696 |
|---|---|
| Coefficient of variation (CV) | 0.63241824 |
| Kurtosis | 4.3226874 |
| Mean | 0.24026341 |
| Median Absolute Deviation (MAD) | 0.083338956 |
| Skewness | 1.4836942 |
| Sum | 181.63914 |
| Variance | 0.02308788 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.037 | 4 | 0.5% |
| 0.0666 | 3 | 0.4% |
| 0.2641 | 3 | 0.4% |
| 0.0805 | 3 | 0.4% |
| 0.0626 | 3 | 0.4% |
| 0.0337 | 2 | 0.3% |
| 0.1788 | 2 | 0.3% |
| 0.0452 | 2 | 0.3% |
| 0.189376858 | 2 | 0.3% |
| 0.1726 | 2 | 0.3% |
| Other values (684) | 730 |
| Value | Count | Frequency (%) |
| 0.0287 | 1 | 0.1% |
| 0.0298 | 1 | 0.1% |
| 0.0304 | 1 | 0.1% |
| 0.0311 | 1 | 0.1% |
| 0.0329 | 1 | 0.1% |
| 0.0337 | 2 | |
| 0.0346 | 1 | 0.1% |
| 0.0359 | 2 | |
| 0.0362 | 1 | 0.1% |
| 0.037 | 4 |
| Value | Count | Frequency (%) |
| 1.2377 | 1 | |
| 0.9894 | 1 | |
| 0.894 | 1 | |
| 0.8708 | 1 | |
| 0.8445 | 1 | |
| 0.833 | 1 | |
| 0.7649 | 1 | |
| 0.7529 | 1 | |
| 0.7491 | 1 | |
| 0.7028 | 1 |
| oil_brent | oil_dubai | coffee_arabica | coffee_robustas | tea_columbo | tea_kolkata | tea_mombasa | sugar_eu | sugar_us | sugar_world | |
|---|---|---|---|---|---|---|---|---|---|---|
| oil_brent | 1.000 | 0.998 | 0.685 | 0.482 | 0.846 | 0.735 | 0.835 | 0.529 | 0.710 | 0.689 |
| oil_dubai | 0.998 | 1.000 | 0.693 | 0.494 | 0.846 | 0.735 | 0.839 | 0.520 | 0.712 | 0.689 |
| coffee_arabica | 0.685 | 0.693 | 1.000 | 0.860 | 0.641 | 0.732 | 0.774 | 0.347 | 0.642 | 0.616 |
| coffee_robustas | 0.482 | 0.494 | 0.860 | 1.000 | 0.368 | 0.599 | 0.578 | 0.249 | 0.459 | 0.462 |
| tea_columbo | 0.846 | 0.846 | 0.641 | 0.368 | 1.000 | 0.758 | 0.855 | 0.491 | 0.752 | 0.612 |
| tea_kolkata | 0.735 | 0.735 | 0.732 | 0.599 | 0.758 | 1.000 | 0.788 | 0.415 | 0.711 | 0.566 |
| tea_mombasa | 0.835 | 0.839 | 0.774 | 0.578 | 0.855 | 0.788 | 1.000 | 0.401 | 0.694 | 0.601 |
| sugar_eu | 0.529 | 0.520 | 0.347 | 0.249 | 0.491 | 0.415 | 0.401 | 1.000 | 0.485 | 0.379 |
| sugar_us | 0.710 | 0.712 | 0.642 | 0.459 | 0.752 | 0.711 | 0.694 | 0.485 | 1.000 | 0.777 |
| sugar_world | 0.689 | 0.689 | 0.616 | 0.462 | 0.612 | 0.566 | 0.601 | 0.379 | 0.777 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| date | oil_brent | oil_dubai | coffee_arabica | coffee_robustas | tea_columbo | tea_kolkata | tea_mombasa | sugar_eu | sugar_us | sugar_world | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1960-01-01 | 1.63 | 1.63 | 0.9409 | 0.696864 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.116845 | 0.0666 |
| 1 | 1960-02-01 | 1.63 | 1.63 | 0.9469 | 0.688707 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.119049 | 0.0679 |
| 2 | 1960-03-01 | 1.63 | 1.63 | 0.9281 | 0.688707 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.121254 | 0.0683 |
| 3 | 1960-04-01 | 1.63 | 1.63 | 0.9303 | 0.684519 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.123459 | 0.0681 |
| 4 | 1960-05-01 | 1.63 | 1.63 | 0.9200 | 0.690692 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.121254 | 0.0683 |
| 5 | 1960-06-01 | 1.63 | 1.63 | 0.9123 | 0.696864 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.125663 | 0.0666 |
| 6 | 1960-07-01 | 1.63 | 1.63 | 0.9160 | 0.690692 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.132277 | 0.0728 |
| 7 | 1960-08-01 | 1.63 | 1.63 | 0.9292 | 0.698848 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.127868 | 0.0741 |
| 8 | 1960-09-01 | 1.63 | 1.63 | 0.9226 | 0.702817 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.132277 | 0.0725 |
| 9 | 1960-10-01 | 1.63 | 1.63 | 0.9237 | 0.706785 | 0.930301 | 1.121401 | 1.0374 | 0.122356 | 0.130073 | 0.0538 |
| date | oil_brent | oil_dubai | coffee_arabica | coffee_robustas | tea_columbo | tea_kolkata | tea_mombasa | sugar_eu | sugar_us | sugar_world | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 746 | 2022-03-01 | 115.59 | 113.11 | 5.698502 | 2.288836 | 3.350000 | 1.955946 | 2.535000 | 0.359836 | 0.800938 | 0.419980 |
| 747 | 2022-04-01 | 105.78 | 102.68 | 5.854148 | 2.291041 | 4.090000 | 3.107004 | 2.525000 | 0.353469 | 0.813505 | 0.433428 |
| 748 | 2022-05-01 | 112.37 | 108.32 | 5.741271 | 2.272963 | 3.710000 | 2.869083 | 2.376667 | 0.345468 | 0.802041 | 0.428799 |
| 749 | 2022-06-01 | 120.08 | 115.73 | 6.033824 | 2.288616 | 3.510000 | 3.272832 | 2.110000 | 0.345305 | 0.793002 | 0.417775 |
| 750 | 2022-07-01 | 108.92 | 106.48 | 5.639197 | 2.212116 | 4.010000 | 3.550721 | 2.365000 | 0.332601 | 0.767869 | 0.402784 |
| 751 | 2022-08-01 | 98.60 | 97.75 | 5.917861 | 2.417366 | 4.210000 | 3.538154 | 2.360000 | 0.330773 | 0.782199 | 0.393525 |
| 752 | 2022-09-01 | 90.16 | 90.63 | 5.897138 | 2.455065 | 4.490000 | 3.153198 | 2.360000 | 0.323621 | 0.770956 | 0.390659 |
| 753 | 2022-10-01 | 93.13 | 90.59 | 5.292852 | 2.270979 | 4.135621 | 2.833112 | 2.457500 | 0.320943 | 0.762578 | 0.386911 |
| 754 | 2022-11-01 | 91.07 | 86.28 | 4.715462 | 2.041258 | 3.831528 | 2.849979 | 2.490000 | 0.332993 | 0.792340 | 0.407414 |
| 755 | 2022-12-01 | 80.90 | 76.78 | 4.629482 | 2.045446 | 3.994073 | 2.421516 | 2.386667 | 0.345729 | 0.805127 | 0.417335 |